AdProgramVersion

Logical Entity Name | AdProgramVersion
Default Table Name | AdProgramVersion
Physical Only | NO
Owner | dbo
Definition |
Note |

AdProgramVersion Columns

ColumnName | Domain | Datatype | NULL | Definition
AdProgramVersionID |  | int | NO |
AdProgramID |  | int | NO |
AdDegreeID |  | int | NO |
AdProgramGroupID |  | int | YES |
Code |  | nvarchar(20) | NO |
Descrip |  | nvarchar(150) | NO |
SyCampusGrpID |  | int | NO |
CreditsReq |  | numeric(7, 2) | NO |
HoursReq |  | numeric(7, 2) | NO |
AdGradeScaleID |  | int | NO |
WeightedGPA |  | bit | NO |
SaBillingMethodID |  | int | YES |
SaEarningsMethodID |  | int | YES |
RefundBasedOn |  | char(1) | NO |
AdSapTableID |  | int | NO |
AdHonorsTableID |  | int | YES |
TotalWeeks |  | numeric(7, 2) | NO |
TotalMonths |  | numeric(7, 2) | NO |
MonthsTerm |  | int | NO |
WeeksTerm |  | int | NO |
TotalLessons |  | numeric(3, 0) | NO |
FaAcademicCalendar |  | char(1) | YES |
ActiveWhen |  | char(1) | YES |
ActiveUnits |  | smallint | YES |
DaysBetweenLessons |  | smallint | YES |
NumberExtensions |  | smallint | YES |
CampusLicenseUnit |  | char(1) | NO |
CreditsInFullAY |  | numeric(7, 2) | NO |
WeeksInFullAY |  | numeric(7, 2) | NO |
FullTime |  | numeric(7, 2) | YES |
HalfTime |  | numeric(7, 2) | YES |
LessThanHalfTime |  | numeric(7, 2) | YES |
ThreeQtrTime |  | numeric(7, 2) | YES |
FaPaymentMethodology |  | char(1) | YES |
SDF1 |  | varchar(50) | YES |
SDF2 |  | varchar(50) | YES |
SDF3 |  | varchar(50) | YES |
SDF4 |  | varchar(50) | YES |
Active |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
TermsInAY |  | int | YES |
TotalBooksSuppliesCost |  | money | YES |
TotalOtherCost |  | money | YES |
TotalTuitionCost |  | money | YES |
ReturnOfT4Period |  | char(1) | YES |
RevenueUnits |  | numeric(7, 0) | YES |
DegreeProgram |  | bit | NO |
RevenuePeriod |  | char(1) | YES |
ClockCredit |  | char(1) | NO |
ClockToCredit |  | bit | NO |
ServicerProgramID |  | varchar(16) | YES |
ReqExtStartDate |  | bit | NO |
ReqEnglishProficiency |  | bit | NO |
NoEPReqReason |  | varchar(2000) | YES |
ClockToCreditRate |  | numeric(6, 2) | NO |
MinOnlineRegCredits |  | numeric(9, 2) | YES |
MaxOnlineRegCredits |  | numeric(9, 2) | YES |
AllowRegOutsideProg |  | bit | NO |
AdGradeLevelPromotionID |  | int | YES |
HoursYear1 |  | numeric(9, 2) | NO |
HoursYear2 |  | numeric(9, 2) | NO |
HoursYear3 |  | numeric(9, 2) | NO |
HoursYear4 |  | numeric(9, 2) | NO |
Comment |  | varchar(1000) | YES |
CreditsYear1 |  | numeric(9, 2) | NO |
CreditsYear2 |  | numeric(9, 2) | NO |
CreditsYear3 |  | numeric(9, 2) | NO |
CreditsYear4 |  | numeric(9, 2) | NO |
ProrateCostOption |  | int | NO |
ExpectedCreditsPerTerm |  | numeric(7, 2) | YES |
FaBudgetID |  | int | YES |
SaCourseRefundPolicyID |  | int | YES |
IsUndeclared |  | bit | NO |
RequiresAreaOfStudy |  | bit | NO |
CIPCode |  | varchar(7) | YES |
TotalCreditsForExternship |  | numeric(7, 2) | NO |
TotalHoursForExternship |  | numeric(9, 2) | NO |
ExpectedHoursPerWeekForExternship |  | numeric(9, 2) | NO |
NumPaymentPeriodsT4AcadYear |  | int | NO |
NumPaymentPeriodsNonT4AcadYear |  | int | NO |
TranscriptDescrip |  | nvarchar(500) | YES |
ReturnOfT4PeriodReenroll |  | char(1) | YES |
ReturnOfT4EnrollmentPeriodType |  | char(1) | YES |
DoNotUsePaymentPeriods |  | bit | YES |
IncludeRevIn9010Report |  | bit | NO |
AcademicYearType |  | char(1) | YES |
CrmSuppressFlag |  | bit | NO |
requiredtotakeattendance |  | bit | NO |
TitleIVEligible |  | bit | NO |
SummerTermHeaderOrTrailer |  | tinyint | NO |
SummerTermPackaging |  | bit | NO |
SummerTermCredits |  | numeric(9, 4) | NO |
CreditBalanceScheduling |  | char(2) | YES |
CreditBalanceSchedulingDays |  | smallint | YES |
PaymentPeriodSAP |  | bit | NO |
ClockToCreditRate1 |  | numeric(6, 2) | NO |
ClockToCredit1 |  | bit | NO |
IncrementalBillEarn |  | bit | NO |
RestrictWaitListing |  | bit | NO |
firstMonthPercentage |  | numeric(5, 2) | YES |
UseScheduledHours |  | bit | YES |
AttWithdrawalDateOption |  | varchar(8) | YES |
FaAutorecalculatebudget |  | bit | NO |
DefaultSpecialProgramType |  | char(1) | NO |
OutsideCourseWorkHours |  | numeric(9, 2) | NO |
FaCredits |  | numeric(9, 2) | NO |
NonSE9W |  | bit | NO |
ProgramLengthType |  | char(1) | YES |
ProgramLengthValue |  | varchar(7) | YES |
AdCourseFulfillmentOrderId |  | int | YES |
CurrentAdCIPCodeYearId |  | int | YES |
overallApprovedTransferCredit |  | money | NO |
MinGPA |  | numeric(11, 6) | YES |
ProgramVersionMaxTransferCredit |  | money | YES |
TotalApprovedTransferCredit |  | money | YES |
DaysToNextAwardYear |  | tinyint | NO |
isGlobalCumulativeInclude |  | bit | NO |
MonthsInAYSummer |  | numeric(2, 1) | YES |
MonthsInAYFall |  | numeric(2, 1) | YES |
MonthsInAYWinter |  | numeric(2, 1) | YES |
MonthsInAYSpring |  | numeric(2, 1) | YES |
isTermsInAYVary |  | bit | NO |
IsCaSTRFResidency |  | bit | NO |
IsEnabledMultipleFulfillment |  | bit | YES |
NoOfCategoriesForMF |  | int | YES |

AdProgramVersion Primary and Unique Keys

Key Name | Key Type | Keys
AdProgramVersion_AdProgramVersionID_ClockCredit_U_N_IDX | Index | AdProgramVersionID, ClockCredit
AdProgramVersion_AdProgramVersionID_U_C_IDX | PrimaryKey | AdProgramVersionID

AdProgramVersion Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AdGradeLevelPromotion | Non-Identifying | Zero or One to Zero or More | FK_AdProgramVersion.AdGradeLevelPromotionID_AdGradeLevelPromotion.AdGradeLevelPromotionID |  |  | AdGradeLevelPromotionID | NO | YES
AdCourseFulfillmentOrder | Non-Identifying | Zero or One to Zero or More | FK_AdProgramVersion_AdCourseFulfillmentOrderId_AdCourseFulfillmentOrder_AdCourseFulfillmentOrderId |  |  | AdCourseFulfillmentOrderId | NO | YES
AdDegree | Non-Identifying | One To Zero or More | FK_AdProgramVersion_AdDegreeID_AdDegree_AdDegreeID |  |  | AdDegreeID | NO | YES
AdProgramGroup | Non-Identifying | Zero or One to Zero or More | FK_AdProgramVersion_AdProgramGroupID_AdProgramGroup_AdProgramGroupID |  |  | AdProgramGroupID | NO | YES
adCIPCode | Non-Identifying | Zero or One to Zero or More | FK_AdProgramVersion_CIPCode_adCIPCode_CIPCode |  |  | CIPCode | NO | YES
AdCIPCodeYear | Non-Identifying | Zero or One to Zero or More | FK_AdProgramVersion_CurrentAdCIPCodeYearId_AdCIPCodeYear_AdCIPCodeYearId |  |  | CurrentAdCIPCodeYearId | NO | YES
FABudget | Non-Identifying | Zero or One to Zero or More | FK_AdProgramVersion_FaBudgetID_FaBudget_FaBudgetID |  |  | FaBudgetID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AdApprovedTransferCreditRestrictions | Non-Identifying | One To Zero or More | FK_AdApprovedTransferCreditRestrictions_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdCipCodeReporting | Non-Identifying | One To Zero or More | FK_AdCipCodeReporting_AdProgramVersionId_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdConcentrationByProgramVersion | Non-Identifying | One To Zero or More | FK_AdConcentrationByProgramVersion_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdDegreePathwayTemplate | Non-Identifying | One To Zero or More | FK_AdDegreePathwayTemplate_AdProgramVersionId_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdEnroll | Non-Identifying | One To Zero or More | FK_AdEnroll_adProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdEnrollDegreeAuditCourseCategory | Non-Identifying | One To Zero or More | FK_AdEnrollDegreeAuditCourseCategory_AdProgramversionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdEnrollDegreeAuditRequirementRule | Non-Identifying | One To Zero or More | FK_AdEnrollDegreeAuditRequirementRule_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdGainfulEmploymentConfiguration | Non-Identifying | One To Zero or More | FK_AdGainfulEmploymentConfigurationAdProgramVersionId_AdProgramVersionAdProgramVersionId |  |  |  | NO | YES
AdIPEDSDistEdCriteriaDetail | Non-Identifying | One To Zero or More | FK_AdIPEDSDistEdCriteriaDetail_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdProgramCourse | Non-Identifying | One To Zero or More | FK_AdProgramCourse_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdProgramFee | Non-Identifying | One To Zero or More | FK_AdProgramFee_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdProgramTermsInAY | Non-Identifying | One To Zero or More | FK_AdProgramTermsInAYAdProgramVersionID_AdProgramVersionAdProgramVersionID |  |  |  | NO | YES
adProgramVersionExternalMap | Non-Identifying | One To Zero or More | FK_adProgramVersionExternalMapadProgramVersionId_adProgramVersionadProgramVersionId |  |  |  | NO | YES
AdProgramVersionProgramGroup | Non-Identifying | One To Zero or More | Fk_AdProgramVersionProgramGroup_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdProgramVersionRequirementRule | Non-Identifying | One To Zero or More | FK_AdProgramVersionRequirementRule_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdProgramVersionToSOCRelationship | Non-Identifying | One To Zero or More | FK_AdProgramVersionToSOCRelationshipAdProgramVersionId_AdProgramVersion_AdProgramVersionId |  |  |  | NO | YES
AdStartDate | Non-Identifying | One To Zero or More | FK_AdStartDate_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdStudentDegreePathway | Non-Identifying | One To Zero or More | FK_AdStudentDegreePathway_AdProgramVersionId_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdStudentTermSequenceHeader | Non-Identifying | One To Zero or More | FK_AdStudentTermSequenceHeader_AdProgramVersionID _AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdStudentTransferHeader | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_FromAdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdStudentTransferHeader | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_ToAdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdTermProgramAssociation | Non-Identifying | One To Zero or More | FK_AdTermProgramAssociationAdProgramVersionID_AdProgramVersionAdProgramVersionID |  |  |  | NO | YES
AdTermSequenceStartDate | Non-Identifying | One To Zero or More | FK_AdTermSequenceStartDate_AdTSStartDateProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AdTermSequenceTemplate | Non-Identifying | One To Zero or More | FK_AdTermSequenceTemplate_AdTermSequenceProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
AmApplicant | Non-Identifying | One To Zero or More | FK_AmApplicant_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
FaCashPlanConfigRelationship | Non-Identifying | One To Zero or More | FK_FaCashPlanConfigRelationshipAdProgramVersionId_AdProgramVersionAdProgramVersionId |  |  |  | NO | YES
FaCfpGrantOptionsConfig_Regulatory | Non-Identifying | One To Zero or More | FK_FaCfpGrantOptionsConfig_RegulatoryAdProgramVersionId_AdProgramVersionAdProgramVersionId |  |  |  | NO | YES
FaEstimate | Non-Identifying | One To Zero or More | FK_FaEstimate_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
faExcusedAbsencePolicyDetail | Non-Identifying | One To Zero or More | FK_faExcusedAbsencePolicyDetail_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
FaMultiDisbSchedRuleCriteria | Non-Identifying | One To Zero or More | FK_FaMultiDisbSchedRuleCriteria_AdProgramVersionID_AdProgramVersion |  |  |  | NO | YES
FaProgramBudgetCost | Non-Identifying | One To Zero or More | FK_FaProgramBudgetCost_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
FaProgramVersion_PaymentPeriod | Non-Identifying | One To Zero or More | FK_FaProgramVersion_PaymentPeriod_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
FaProgramVersion_PaymentPeriodNonTitleIV | Non-Identifying | One To Zero or More | FK_FaProgramVersion_PaymentPeriodNonTitleIV_AdProgramVersionId_AdProgramVersion_AdProgramVersionId |  |  |  | NO | YES
FaProgramVersionCOA | Non-Identifying | One To Zero or More | FK_FaProgramVersionCOA_AdProgramVersionId_AdProgramVersion_AdProgramVersionId |  |  |  | NO | YES
FaShoppingSheet | Non-Identifying | One To Zero or More | FK_FaShoppingSheet_AdProgramVersion |  |  |  | NO | YES
FaShoppingSheetCostsConfig | Non-Identifying | One To Zero or More | FK_FaShoppingSheetCostsConfigAdProgramVersionId_AdProgramVersionAdProgramVersionId |  |  |  | NO | YES
FaShoppingSheetLoanOptionsConfig | Non-Identifying | One To Zero or More | FK_FaShoppingSheetLoanOptionsConfigAdProgramVersionId_AdProgramVersionAdProgramVersionId |  |  |  | NO | YES
FAStudentCredits | Non-Identifying | One To Zero or More | FK_FAStudentCredits_AdProgramVersionId_AdProgramVersion_AdProgramVersionId |  |  |  | NO | YES
FaTermAssociationTrackProgramVersion | Non-Identifying | One To Zero or More | FK_FaTermAssociationTrackProgramVersion_AdProgramVersionId_AdProgramVersion_AdProgramVersionId |  |  |  | NO | YES
FaTermTrackProgramAssociation | Non-Identifying | One To Zero or More | FK_FaTermTrackProgramAssociation_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES
SAAutoChargeProgramVersion | Non-Identifying | One To Zero or More | FK_SAAutoChargeProgramVersion_AdProgramVersionID_AdProgramVersion_AdProgramVersionId |  |  |  | NO | YES
SaBillCodeRevenuePeriod | Non-Identifying | One To Zero or More | FK_SaBillCodeRevenuePeriod_AdProgramVersionID_AdProgramVersion_AdProgramVersionID |  |  |  | NO | YES

AdProgramVersion Check Constraints

Check Constraint Name | CheckConstraint

AdProgramVersion Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

AdProgramVersion Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.ProgramVersion | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdProgramVersion | NO |  |  |

AdProgramVersion Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | DegreePathway
Logical | Documents
Logical | Program/ProgramVersion
Logical | StudentEnrollment
Logical | StudentPlacementPreferences
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

AdProgramVersion Data Movement Rules

Name | Type | Rule Text/Value